﻿using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using WarehouseManager.Core;

namespace WarehouseManager.DataAccess
{
    
    class ThongkeAccess
    {
        dbConnection dbCon = new dbConnection();
        public ThongkeAccess()
        {
        }
        public DataTable layThongtinkho()
        {
            return dbCon.executeSelectProcedureQueryNonParameter("proc_selectThongKeKho");
        }
        public DataTable layThongtinkhotheomahh(string s)
        {
            SqlParameter[] listParam = new SqlParameter[1];
            SqlParameter temp = new SqlParameter("@maHH",SqlDbType.VarChar,10);
            temp.Value = s;
            listParam[0] = temp;
            return dbCon.executeSelectProcedureQuery("proc_selectIDHanghoa", listParam);
        }
    }
}
